AVERAGEROUND

Rounds all numbers in a specified range to a specified number of digits, then returns the average (arithmetic mean) of all the rounded figures.

Syntax

AVERAGEROUND(range_input, decimal_places)

range_input - is the range for which you want to calculate the average.

decimal_places - specifies the number of digits to which you want to round numbers.

Remark

• Arguments that are error values or text that cannot be translated into numbers cause errors. See the third example below.
• If decimal_places is greater than 0 (zero), then numbers are rounded to the specified number of decimal places.
• If decimal_places is 0, then numbers are rounded to the nearest integer.
• If decimal_places is less than 0, then numbers are rounded to the left of the decimal point.

Examples

• AVERAGEROUND(A1:A2,0) equals 6
• AVERAGEROUND (A1:A3,0) equals 6 because the text values are translated into numbers, and the logical value TRUE is translated into the number 1.
• AVERAGEROUND (A1:A4,1) returns a #VALUE! error, because the word "Apple" in cells A4 is text. See Also : SUMROUND PRODUCTROUND

 

[ ©2000-2001, Edwin H. B. Tam, All rights reserved ]